(Quick Reference)
findWhere
Purpose
Uses named arguments corresponding to domain class property names to execute a query returning the first matching result.
Examples
Given the domain class:
class Book { String title
Date releaseDate
String author static constraints = {
releaseDate nullable: true
}
}You can query in the form:
def book = Book.findWhere(author: "Stephen King", title: "The Stand")boolean isReleased = Book.findWhere(author: "Stephen King",
title: "The Stand",
releaseDate: null) != nullDescription
Parameters:
queryParams - A Map of key/value pairs to be used in the query
